package jdbc;
/**
 * 根据给定的用户名删除指定用户
 */
import javax.jws.soap.SOAPBinding;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

public class Test {
    public static void main(String[] args) {
            UserInfo userInfo = InputUtil.getInputObject(new UserInfo(),"删除用户","删除");
            System.out.println(userInfo);
            try(
                    Connection connection = DBUtil.getConnection();
            ){
                Statement statement = connection.createStatement();
                String sql = "DELETE FROM userinfo " +
                        "WHERE username='"+userInfo.getUsername()+"'";
                int num = statement.executeUpdate(sql);
                System.out.println("删除"+(num>0?"成功":"失败"));

            }catch(Exception e){
                e.printStackTrace();
            }

        }
    }
